{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Linearity","Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 02-Aug-2023. Last reviewed on 09-Jun-2023.\r\nVAL 2003 (version 1.1). Quantitative Linearity Pack. Page 1 of 3"]
["Please refer to VAL 2001 Quantitative Validation Guidelines for additional guidance and instructions."]
[]
["Linearity- Plot the data in regression analysis program.  The pSMILE Linearity spreadsheet performs all necessary calculations. "]
[]
["1. Plot the known values of the standards on the X-axis (Assigned Column)"]
["2. Plot the mean of the measured values on the Y-axis. (Under Measured-Rep 1, 2, or 3 reps)"]
["4. Calculate slope and intercept using linear regression. This can be done using the Excel SLOPE and INTERCEPT functions or from the website http://tools.westgard.com/cgi-bin/westgard/comp_calc.cgi?header=http:/www.westgard.com/images/headtoolkit.gif"]
["5. Using slope and intercept, calculate a predicted Y value for each X value."]
["6. Plot the predicted Y values versus the corresponding known X values on the same graph mentioned in 1 and 2 above. Draw a straight line to connect all the predicted Y points on the graph."]
["7. Subtract each measured Y value from the associated predicted Y value. This difference is the systematic error due to non-linearity."]
["8. Compare that systematic error to 50% of the total error.  The systematic error must be less than 50% of the total error."]
["9. The method is linear if the difference between the predicted Y value and the measured Y value is less than the allowable error for each specimen point."]

{"sheet":"Linearity","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,0,7,3],[2,0,2,2],[3,0,3,2],[3,8,3,11],[2,3,2,7],[3,3,3,7],[2,9,2,11],[23,0,23,1],[22,0,22,1],[14,10,14,11],[8,10,8,11],[9,10,9,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 02-Aug-2023. Last reviewed on 09-Jun-2023.\r\nVAL 2003 (version 1.1). Quantitative Linearity Pack. Page 2 of 3"]
["Method Being Evaluated:",{"$nulls":7},"Date:"]
["Analyte:",{"$nulls":7},"Total Allowable Error (TEa):"]
[null,null,"Units:",{"$nulls":5},"Conc.:",null,"Percent:"]
[{"$nulls":6},"Manufacturer's stated analytical measurement range:"]
[{"$nulls":6},"Low:",null,"High:"]
["Measured"]
["Rep 1","Rep 2","Rep 3","Avg","Assigned","Target","± Diff","% Diff","± Limit","% Limit","Grade"]
[null,null,null,{"$f":"AVERAGE(A10:C10)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E10*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D10-F10","v":{"$error":"#DIV/0!"}},{"$f":"(G10/F10)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F10*$L$5*0.5,J5,F10*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G10)<I10,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K10=\"Acceptable\",\"A\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(A11:C11)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E11*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D11-F11","v":{"$error":"#DIV/0!"}},{"$f":"(G11/F11)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F11*$L$5*0.5,J5,F11*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G11)<I11,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K11=\"Acceptable\",\"B\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(A12:C12)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E12*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D12-F12","v":{"$error":"#DIV/0!"}},{"$f":"(G12/F12)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F12*$L$5*0.5,J5,F12*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G12)<I12,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K12=\"Acceptable\",\"C\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(A13:C13)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E13*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D13-F13","v":{"$error":"#DIV/0!"}},{"$f":"(G13/F13)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F13*$L$5*0.5,J5,F13*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G13)<I13,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K13=\"Acceptable\",\"D\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(A14:C14)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E14*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D14-F14","v":{"$error":"#DIV/0!"}},{"$f":"(G14/F14)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F14*$L$5*0.5,J5,F14*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G14)<I14,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K14=\"Acceptable\",\"E\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"AVERAGE(A15:C15)","v":{"$error":"#DIV/0!"}},null,{"$f":"(E15*$B$20)+$B$19","v":{"$error":"#VALUE!"}},{"$f":"D15-F15","v":{"$error":"#DIV/0!"}},{"$f":"(G15/F15)","v":{"$error":"#DIV/0!"}},{"$f":"IF($J$5>F15*$L$5*0.5,J5,F15*$L$5*0.5)","v":{"$error":"#VALUE!"}},{"$f":"$L$5*0.5","v":0},{"$f":"IF(ABS(G15)<I15,\"Acceptable\",\"Unacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K15=\"Acceptable\",\"F\",\"\")","v":{"$error":"#DIV/0!"}}]
[{"$nulls":12},{"$f":"M10&M11&M12&M13&M14&M15","v":{"$error":"#DIV/0!"}}]
[{"$nulls":7},{"$f":"LINEST(D10:D15,E10:E15,TRUE,TRUE)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,null,{"$f":"INDEX(K18:K38,MATCH(M16,J18:J38,0))","v":{"$error":"#DIV/0!"}}]
[null,"Coefficients","Std Err",{"$nulls":4},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ABCDEF",{"$f":"D10&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
["Intercept",{"$f":"I17","v":{"$error":"#VALUE!"}},{"$f":"I18","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ABCDE",{"$f":"D10&\" \"&\"to\"&\" \"&D14","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D14","v":{"$error":"#DIV/0!"}}]
["Slope",{"$f":"H17","v":{"$error":"#VALUE!"}},{"$f":"H18","v":{"$error":"#VALUE!"}},{"$nulls":4},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ABCD ",{"$f":"D10&\" \"&\"to\"&\" \"&D13","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}}]
["Correl. (r)",{"$f":"CORREL(D10:D15,E10:E15)","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ABC",{"$f":"D10&\" \"&\"to\"&\" \"&D12","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}}]
[{"$nulls":9},"ACDEF",{"$f":"D12&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
["Your Linearity Evaluation:",null,{"$f":"IF(ISERROR(M17),\"NON-LINEAR\",\"LINEAR\")","v":"NON-LINEAR"},{"$f":"IF(ISERROR(M17),\"\",M17)","v":""},{"$f":"IF(M16=\"ABCDEF\",\"FULL RANGE TESTED\",\"PARTIAL RANGE\")","v":{"$error":"#DIV/0!"}},{"$nulls":4},"ABDEF",{"$f":"D13&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
["Verified AMR:",null,{"$f":"B27&\" \"&\"to\"&\" \"&E27","v":"0 to 0"},{"$f":"IF(D5=0,\"\",D5)","v":""},{"$nulls":5},"ABCEF",{"$f":"D10&\" \"&\"to\"&\" \"&D12","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"INDEX(C25:C26,MATCH(H7,C25:C26,-1))","v":{"$error":"#N/A"}},{"$f":"INDEX(L18:L38,MATCH(M16,J18:J38,0))","v":{"$error":"#DIV/0!"}},{"$f":"INDEX(M18:M38,MATCH(M16,J18:J38,0))","v":{"$error":"#DIV/0!"}},{"$f":"INDEX(D25:D26,MATCH(J7,D25:D26,1))","v":{"$error":"#N/A"}},{"$nulls":4},"ABCDF",{"$f":"D10&\" \"&\"to\"&\" \"&D13","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(H7+INDEX(I10:I15,MATCH(C25,D10:D15,0))>=B25,B25,C25)","v":{"$error":"#DIV/0!"}},{"$f":"C25-INDEX(I10:I15,MATCH(C25,D10:D15,0))","v":{"$error":"#DIV/0!"}},{"$f":"D25+INDEX(I10:I15,MATCH(D25,D10:D15,0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(J7-INDEX(I10:I15,MATCH(D25,D10:D15,0))<=E25,E25,D25)","v":{"$error":"#DIV/0!"}},{"$nulls":4},"BCDEF",{"$f":"D11&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D11","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISERROR(B26),H7,B26)","v":0},null,null,{"$f":"IF(ISERROR(E26),J7,E26)","v":0},{"$nulls":4},"BCDE",{"$f":"D11&\" \"&\"to\"&\" \"&D14","v":{"$error":"#DIV/0!"}},{"$f":"D11","v":{"$error":"#DIV/0!"}},{"$f":"D14","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"B19","v":{"$error":"#VALUE!"}},0,null,"BCD",{"$f":"D11&\" \"&\"to\"&\" \"&D13","v":{"$error":"#DIV/0!"}},{"$f":"D11","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"E10","v":0},null,"ABCE ",{"$f":"D10&\" \"&\"to\"&\" \"&D12","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}}]
[{"$nulls":9},"CDEF",{"$f":"D12&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F10-I10","v":{"$error":"#VALUE!"}},{"$f":"F10+I10","v":{"$error":"#VALUE!"}},null,"CDE",{"$f":"D12&\" \"&\"to\"&\" \"&D14","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}},{"$f":"D14","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F11-I11","v":{"$error":"#VALUE!"}},{"$f":"F11+I11","v":{"$error":"#VALUE!"}},null,"ABCDF",{"$f":"D10&\" \"&\"to\"&\" \"&D13","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F12-I12","v":{"$error":"#VALUE!"}},{"$f":"F12+I12","v":{"$error":"#VALUE!"}},null,"DEF",{"$f":"D13&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F13-I13","v":{"$error":"#VALUE!"}},{"$f":"F13+I13","v":{"$error":"#VALUE!"}},null,"ADEF",{"$f":"D13&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F14-I14","v":{"$error":"#VALUE!"}},{"$f":"F14+I14","v":{"$error":"#VALUE!"}},null,"BDEF",{"$f":"D13&\" \"&\"to\"&\" \"&D15","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}},{"$f":"D15","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"F15-I15","v":{"$error":"#VALUE!"}},{"$f":"F15+I15","v":{"$error":"#VALUE!"}},null,"ABCF",{"$f":"D10&\" \"&\"to\"&\" \"&D12","v":{"$error":"#DIV/0!"}},{"$f":"D10","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}}]
[{"$nulls":9},"BCDF",{"$f":"D11&\" \"&\"to\"&\" \"&D13","v":{"$error":"#DIV/0!"}},{"$f":"D11","v":{"$error":"#DIV/0!"}},{"$f":"D13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":9},"ACDE ",{"$f":"D12&\" \"&\"to\"&\" \"&D14","v":{"$error":"#DIV/0!"}},{"$f":"D12","v":{"$error":"#DIV/0!"}},{"$f":"D14","v":{"$error":"#DIV/0!"}}]

{"sheet":"Sheet1","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 02-Aug-2023. Last reviewed on 09-Jun-2023.\r\nVAL 2003 (version 1.1). Quantitative Linearity Pack. Page 3 of 3"]
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 09-Jun-2023. Last reviewed on 09-Jun-2023.\r\nVAL 2003 (version 1.0). Quantitative Linearity Pack. Page 2 of 2"]
{"$rows_empty":20}
["sheet1"]